package edu.gatech.mobile.scene.provider.impl;

import android.net.Uri;
import android.provider.BaseColumns;
import edu.gatech.mobile.scene.provider.TableSchema;

/**
 * class specifying the colorHistogramTable schema.
 * @author Jing
 *
 */

public class ColorHistogramTable extends TableSchema{

	// Database table name
	public static final String TABLE_NAME = "color_histogram";

	// Base MIME type for the entity table.
	private static final String TABLE_TYPE = "vnd.en.color_histogram";

	public static final Uri CONTENT_URI = Uri.parse("content://"
			+ ProprioVisionSchema.AUTHORITY + "/color_histogram");
	
	
	public static final String SORT_ORDER = BaseColumns._ID +" ASC";

	//Columns in the database.
	public static final String TIME_POSTED ="time_posted";
	public static final String TRUTH_LABEL_NAME = "truth_label_name";
	public static final String MASK_ID = "mask_id";
	public static final String CHANNEL = "channel";
	
	public static final String HISTOGRAM_VALUE = "histogram_value_";
	public static final String HISTOGRAM_VALUE_0 = "histogram_value_0";
	public static final String HISTOGRAM_VALUE_1 = "histogram_value_1";
	public static final String HISTOGRAM_VALUE_2 = "histogram_value_2";
	public static final String HISTOGRAM_VALUE_3 = "histogram_value_3";
	public static final String HISTOGRAM_VALUE_4 = "histogram_value_4";
	public static final String HISTOGRAM_VALUE_5 = "histogram_value_5";
	public static final String HISTOGRAM_VALUE_6 = "histogram_value_6";
	public static final String HISTOGRAM_VALUE_7 = "histogram_value_7";
	public static final String HISTOGRAM_VALUE_8 = "histogram_value_8";
	public static final String HISTOGRAM_VALUE_9 = "histogram_value_9";
	public static final String HISTOGRAM_VALUE_10 = "histogram_value_10";
	public static final String HISTOGRAM_VALUE_11 = "histogram_value_11";
	public static final String HISTOGRAM_VALUE_12 = "histogram_value_12";
	public static final String HISTOGRAM_VALUE_13 = "histogram_value_13";
	public static final String HISTOGRAM_VALUE_14 = "histogram_value_14";
	public static final String HISTOGRAM_VALUE_15 = "histogram_value_15";
	
	
	//Specifying the data type for each column
	private static final String[][] FIELDS = {{MASK_ID, "INTEGER"}, 
		{HISTOGRAM_VALUE_0, "REAL"}, {HISTOGRAM_VALUE_1, "REAL"}, {HISTOGRAM_VALUE_2, "REAL"}, {HISTOGRAM_VALUE_3, "REAL"}, 
		{HISTOGRAM_VALUE_4, "REAL"}, {HISTOGRAM_VALUE_5, "REAL"}, {HISTOGRAM_VALUE_6, "REAL"}, {HISTOGRAM_VALUE_7, "REAL"}, 
		{HISTOGRAM_VALUE_8, "REAL"}, {HISTOGRAM_VALUE_9, "REAL"}, {HISTOGRAM_VALUE_10, "REAL"}, {HISTOGRAM_VALUE_11, "REAL"}, 
		{HISTOGRAM_VALUE_12, "REAL"}, {HISTOGRAM_VALUE_13, "REAL"}, {HISTOGRAM_VALUE_14, "REAL"}, {HISTOGRAM_VALUE_15, "REAL"},  
		{TIME_POSTED, "INTEGER"}, {CHANNEL, "INTEGER"}};
	
	protected ColorHistogramTable() {
		super(TABLE_NAME, TABLE_TYPE, CONTENT_URI, SORT_ORDER, FIELDS);
	}
	
	
}
